{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["coverSheet","Worksheet 1","cockpit calculation ISO 11812","Table 4 calc","Table 4 ","Koeffient C1","C10","Table C2","Koef. C2 Table C3","Koef. C3 Table C4"],"not_rendered":{"charts":3,"images":3,"defined_names":3,"comments":4},"unopened":[{"sheet":"Table 4 ","index":4,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"coverSheet","index":0,"n_rows":29,"n_cols":1,"rows_kept":29,"merged":[[2,0,2,5],[4,1,4,5],[5,1,5,5],[6,1,6,5],[7,1,7,5],[8,1,8,5],[9,1,9,5],[10,1,10,5],[11,1,11,5],[13,0,13,5],[14,0,14,5],[16,0,16,1],[17,0,17,1],[19,0,20,5],[22,0,22,5],[24,0,24,5],[26,0,26,5],[28,0,28,5]]}
[]
[]
["ISO 11812:2001 Small craft - Watertight cockpits and quick-draining cockpits"]
[]
["Manufacturer:"]
["Signatory, Name:"]
["Signatory, Title:"]
["Phone:"]
["Email:"]
["WWW:"]
["CIN Model Year:"]
["Model Name:"]
[]
["This calculation sheet is provided by IMCI \"as is\" and any express or implied warranties, including, but not limited to, the implied warranties of fitness for a particular purpose are disclaimed."]
[]
[]
["blue cells are derived values"]
["yellow cells require data input"]
[]
[]
[]
[]
[" - These worksheets checks the requirements for cockpit drainage solely with the quick method of calculation for cockpits as described in clause 7.8.4 of ISO 11812 for single level cockpits. \nAnnex C or other methods may give other results for the required drainage area.\nNo multilevel cockpit calculation."]
[]
["  - Simplified calculation for drain pipes with a diameter between 25mm and 150mm; bigger ones cannot be calculated with this tool."]
[]
["  - Please attach other detailed information as appropriate, e.g. photos, sketches etc. for sill height, openings, companion way doors, practical tests etc."]
[]
["- Please send questions, found errors, typos, mistakes, ect. directly to ralf.dewender@imci.org or to the headoffice with info@imci.org; every comment helps us to provides you with a better version."]

{"sheet":"Worksheet 1","index":1,"n_rows":81,"n_cols":57,"rows_kept":81,"merged":[[0,0,0,9],[0,11,0,12],[1,0,1,9],[2,0,2,9],[3,0,3,3],[4,0,4,9],[6,14,6,18],[8,0,8,5],[10,11,10,14],[24,11,24,12],[29,11,36,18],[39,11,39,12],[39,13,39,31],[43,0,43,6],[44,0,44,6],[46,0,46,6],[47,0,47,6],[49,15,49,22],[50,15,50,18],[50,19,50,22],[51,19,51,22],[52,19,52,22],[53,19,53,22],[54,19,54,22],[57,0,57,9],[59,15,59,21],[61,16,61,18],[62,15,66,15],[62,16,62,18],[62,19,62,21],[63,17,63,18],[63,20,63,21],[64,11,64,13],[66,13,66,14],[68,13,68,14],[69,13,69,14],[70,13,70,14],[71,13,71,14],[72,15,72,26],[73,13,73,14],[73,16,73,33]]}
[{"$nulls":11},"Comments"]
["ISO 11812:2001 Small craft - Watertight cockpits and quick-draining cockpits",{"$nulls":11},"Derived values"]
["WORKSHEET No. 1 data entry",{"$nulls":11},"Input values"]
["ISO 11812 en190916"]
[{"$f":"CONCATENATE(coverSheet!B5,\"   \",coverSheet!B12)","v":"   "}]
[{"$nulls":28},"Power"]
["Design Category intended:",{"$nulls":4},"    Monohull / Multihull:",null,null,"Boat Type",{"$nulls":19},"Sail"]
[]
["Item",{"$nulls":5},"Symbol","Unit","Value","Ref.",{"$nulls":44},"list:","list:","list:"]
["Length of hull as in ISO 8666",{"$nulls":5},"LH","m",null,"3.2",{"$nulls":18},"A",{"$nulls":25},"A","Monohull","OB"]
["Beam of hull (max)",{"$nulls":5},"Bmax","m",null,"3.3",{"$nulls":18},"B",{"$nulls":25},"B","Multihull"]
["Freeboard amidships",{"$nulls":5},"FM","m",null,"3.5",null,"Additional drains with different diameter",{"$nulls":16},"C",{"$nulls":25},"C"]
["Cockpit Volume",{"$nulls":5},"VC","m³",null,"3.27",null,null,"number","diameter [mm]",null,"area of one drain [mm²]",{"$nulls":12},"D",{"$nulls":25},"D"]
["Cockpit water retention height",{"$nulls":5},"hC","m",null,"3.15",null,"drainsize 2",{"$nulls":3},{"$f":"(N14/2)^2*PI()","v":0}]
["Cockpit bottom height",{"$nulls":5},"hB","m",null,"3.16",null,"drainsize 3",{"$nulls":3},{"$f":"(N15/2)^2*PI()","v":0}]
["Drain lenght",{"$nulls":6},"m",{"$nulls":3},"sum of additional circular drain area",null,null,{"$f":"M14*P14+M15*P15","v":0},"mm²"]
["Number of drains",{"$nulls":6},". /.",{"$nulls":3},"Freeing ports or non-circular drains"]
["Actual Drain diameter",{"$nulls":6},"mm",{"$nulls":3},"please insert number and size of rectangular openings/drains"]
["Drain with / without elbow",{"$nulls":11},"number","length[mm]","width[mm]","area of one drain [mm²]",{"$nulls":12},"none"]
["Drain below  / above waterline",{"$nulls":8},"7.8.4.3",null," opening 1",{"$nulls":3},{"$f":"N20*O20","v":0},"clause 7.4.1",{"$nulls":11},"without flaps"]
["Area of additionall openings (transom door, freeing port, u.a.)",{"$nulls":6},"mm²",{"$f":"O23+L25+O16","v":0},null,null," opening 2",{"$nulls":3},{"$f":"N21*O21","v":0},"minimum dimensions are 20mm in one direction and at minimum an area of 500mm² !"]
["Freeing port with / without flaps",{"$nulls":10}," opening 3",{"$nulls":3},0,{"$nulls":11},"circular","with flaps"]
["Actual height of fixed sill",{"$nulls":5},"hS,min/2","m",null,"3.25",null,"sum of rectangular drain area",null,null,{"$f":"M20*P20+M21*P21+M22*P22","v":0},"mm²",{"$nulls":11},"other shapes"]
["Actual semifixed sill (mobile part) height",{"$nulls":5},"hS,min","m",null,"3.25",null,"Drain area of any other openings (pls insert only sum of all drainage areas which are not circular or rectangular) "]
["Degree of watertightness of the closing appliances in the cockpit (if applicable)",{"$nulls":12},"mm²",{"$nulls":14},1]
["Closing appliances on bottom and horizontal areas; actual degree of watertightness",{"$nulls":8},"9.2.1",{"$nulls":18},2]
["Closing appliances on cockpit sides up to hS,min; actual degree of watertightness",{"$nulls":8},"9.2.1",{"$nulls":18},3]
["Closing appl. on cockpit sides  betw. hS,min and 2 hS,min a; actual degree of watertightness",{"$nulls":8},"9.2.1",{"$nulls":18},4]
["Closing appliances on cockpit sides above 2 hS,min a; actual degree of watertightness",{"$nulls":8},"9.2.1",{"$nulls":18},"n.a."]
["Requirement results, general",{"$nulls":5},"Symbol","Unit","Value","Ref.",null,"7.8.4.4. (NOTE)\nThe time calculations given in Table 4 are for a draining time between a height of water hC = 0,40 m to a remaining 0,10 m of water, with two drains, each one 1,2 m long and a coefficient of head loss at the entry K = 0,06 (see D.3). \nFor different values of hC, the draining time is smaller (multiplied by coefficient C1 of Table C.1). The draining time for a freeing port fitted with flaps is considered as 150 % of the draining time without a flap, this assessment may be adjusted by a test.\nFor a non-circular drain section, the section area shall be the same as that of a circular drain.",{"$nulls":16},"with"]
["Minimum cockpit bottom height",{"$nulls":5},"hB, min","m",{"$f":"IF(I15=\"\",\"\",'cockpit calculation ISO 11812'!D34)","v":""},"3.17",{"$nulls":18},"without"]
["Cockpit volume coefficient",{"$nulls":5},"kC",". /.",{"$f":"'cockpit calculation ISO 11812'!D36","v":"not defined"},"3.28"]
["Acceptable draining time",{"$nulls":5},"t* max","min",{"$f":"'cockpit calculation ISO 11812'!D37","v":"not defined"},"7.2",{"$nulls":18},"above"]
["Acceptable draining time, corr. (tmax with a max. of 5min)",{"$nulls":5},"t max","min",{"$f":"'cockpit calculation ISO 11812'!D38","v":{"v":5,"d":"5.000"}},"7.2",{"$nulls":18},"below"]
["Reference time",{"$nulls":5},"t ref","min",{"$f":"'cockpit calculation ISO 11812'!D39","v":{"v":0,"d":"0.000"}},"7.8.4.2"]
["Results, drain requirements",{"$nulls":6},"Unit","Value","Ref."]
["Drain diameter, required Table 4 value",{"$nulls":6},"mm",{"$f":"IF(AND(I18=\"\",I21=\"\"),\"\",'cockpit calculation ISO 11812'!D41)","v":false},"7.8.4.4"]
["Determination of coefficient C1",{"$nulls":6},". /.",{"$f":"IF(I14=\"\",\"\",'cockpit calculation ISO 11812'!G45)","v":""},"annex C.4"]
["Determination of coefficient C2 or C3",{"$nulls":6},". /.",{"$f":"IF(I16=\"\",\"\",IF('cockpit calculation ISO 11812'!G46=\"\",'cockpit calculation ISO 11812'!G47,'cockpit calculation ISO 11812'!G46))","v":""},"annex C.5"]
["Drain diameter, corrected value with C1,C2 and C3",{"$nulls":6},"mm",{"$f":"IF(AND(I18=\"\",I21=\"\"),\"\",'cockpit calculation ISO 11812'!D42)","v":false},"Table C.2"]
["Cross section, required",{"$nulls":6},"mm²",{"$f":"IF('cockpit calculation ISO 11812'!D43=0,\"***\",'cockpit calculation ISO 11812'!D43)","v":"***"},"Table C.2",null,"*** Please insert number of drains, elbows and above/below for circular drains"]
["Actual cross section",{"$nulls":6},"mm²",{"$f":"'cockpit calculation ISO 11812'!D46","v":{"v":0,"d":"0.0"}},null,null,"or freeing ports with or without flaps"]
["Results, drainage area and cockpit bottom height",{"$nulls":7},"Pass/Fail",null,null,"...otherwise the sheet will not calculate correctly !"]
["Cockpit bottom height",{"$nulls":7},{"$f":"IF(I15=\"\",\"\",IF(I15>=I31,\"Pass\",\"Fail\"))","v":""},"6.1 Table 2"]
["Drainage cross section",{"$nulls":7},{"$f":"IF(AND(I18=\"\",I21=\"\"),\"\",IF(I42>=I41,\"Pass\",\"Fail\"))","v":"Fail"},"Annex C"]
["Results, sill heights",{"$nulls":6},"req.","Pass/Fail"]
["Height of fixed sill",{"$nulls":6},{"$f":"IF(I23=\"\",\"\",'cockpit calculation ISO 11812'!D143)","v":""},{"$f":"IF(I23=\"\",\"\",IF(I23>=H47,\"Pass\",\"Fail\"))","v":""}]
["Height of semifixed sill",{"$nulls":6},{"$f":"IF(I24=\"\",\"\",'cockpit calculation ISO 11812'!D149)","v":""},{"$f":"IF(I24=\"\",\"\",IF(I24>=H48,\"Pass\",\"Fail\"))","v":""}]
["Results, degree of watertightness of closing appliances",{"$nulls":6},"req.","Pass/Fail","Ref."]
["Closing appliances on bottom and horizontal areas",{"$nulls":6},2,{"$f":"IF(I26=\"\",\"\",IF(I26=\"n.a.\",\"n.a.\",IF(I26<=H50,\"Pass\",\"Fail\")))","v":""},"9.2.1 Table 6",{"$nulls":5},"Table 6 — Required degree of watertightness of quick-draining-cockpit closing appliances"]
["Closing appliances on cockpit sides up to hS,min",{"$nulls":6},2,{"$f":"IF(I27=\"\",\"\",IF(I27=\"n.a.\",\"n.a.\",IF(I27<=H51,\"Pass\",\"Fail\")))","v":""},"9.2.1 Table 6",{"$nulls":5},"Location of the closing appliance in the cockpit",{"$nulls":3},"Degree of watertightness"]
["Closing appl. on cockpit sides  betw. hS,min and 2 hS,min a",{"$nulls":6},3,{"$f":"IF(I28=\"\",\"\",IF(I28=\"n.a.\",\"n.a.\",IF(I28<=H52,\"Pass\",\"Fail\")))","v":""},"9.2.1 Table 6",{"$nulls":5},"Closing appliances on bottom and horizontal areas ",{"$nulls":3},2]
["Closing appliances on cockpit sides above 2 hS,min a",{"$nulls":6},4,{"$f":"IF(I29=\"\",\"\",IF(I29=\"n.a.\",\"n.a.\",IF(I29<=H53,\"Pass\",\"Fail\")))","v":""},"9.2.1 Table 6",{"$nulls":5},"Closing appliances on cockpit sides up to hS,min",{"$nulls":3},2]
[{"$nulls":15},"Closing appliances on cockpit sides between hS,min and 2 hS,min a",{"$nulls":3},3]
[{"$nulls":15},"Closing appliances on cockpit sides above 2 hS,min a",{"$nulls":3},4]
[]
[{"$nulls":15},"a hS,min being measured from the nearest part of the cockpit bottom. "]
[{"$nulls":15},"   Informative annex A explains how to consider the main examples of cockpit layout."]
[]
[{"$nulls":15},"Table 5 — Minimum values hS,min for fixed sills and semi-fixed sills"]
[]
[{"$nulls":16},"dimensions in m"]
[{"$nulls":15},"Design Category","Sailing monohulls",null,null,"Non-sailing boats and sailing multihulls"]
[{"$nulls":16},"Fixed sill","Semi-fixed sill",null,"Fixed sill","Semi-fixed sill"]
[{"$nulls":16},"Top of sill","Top of fixed part","Top of mobile part","Top of sill","Top of fixed part","Top of mobile part"]
[]
[{"$nulls":16},"hS,min","hS,min/2","hS,min","hS,min","hS,min/2","hS,min"]
[{"$nulls":15},"A",0.3,0.15,0.3,0.2,0.1,0.2]
[{"$nulls":15},"B",0.25,0.125,0.25,0.15,0.075,0.15]
[{"$nulls":15},"C",0.15,0.075,0.15,0.1,0.05,0.1]
[{"$nulls":15},"D",0.05,0.025,0.05,0.05,0.025,0.05]
[]
[{"$nulls":15},"Table 4 — Drain diameter as a function of tref and typical drain arrangement"]
[{"$nulls":15},"Typical drain arrangement","Values of tref (min)"]
[{"$nulls":15},"Drain outlet above WL, no elbow",8.8,5.8,4.1,3,2.3,1.8,1.5,1.2,1,0.9,0.8,0.7,0.5,0.4,0.3,0.3,0.2,0.2,0.2]
[{"$nulls":15},"Drain outlet above WL, two elbows",10,6.7,4.7,3.5,2.7,2.2,1.8,1.5,1.3,1.1,0.9,0.8,0.6,0.5,0.4,0.4,0.3,0.3,0.2]
[{"$nulls":15},"Drain outlet below WL, no elbow",10.8,7.2,5.1,3.9,3,2.4,2,1.6,1.4,1.2,1,0.9,0.7,0.6,0.5,0.4,0.3,0.3,0.2]
[{"$nulls":15},"Drain outlet below WL, two elbows",11.8,7.9,5.7,4.3,3.3,2.7,2.2,1.8,1.5,1.3,1.2,1,0.8,0.6,0.5,0.4,0.4,0.3,0.3]
[{"$nulls":15},"Freeing port above WL, no flap",10.1,7,5.2,3.9,3.1,2.5,2.1,1.8,1.5,1.3,1.1,1,0.8,0.6,0.5,0.4,0.4,0.3,0.3]
[{"$nulls":15},"Freeings port above WL, with flap",15.2,10.5,7.7,5.9,4.7,3.8,3.1,2.6,2.2,1.9,1.7,1.5,1.2,0.9,0.8,0.7,0.6,0.5,0.4]
[{"$nulls":15},"Drain diameter d (mm) two drains",25,30,35,40,45,50,55,60,65,70,75,80,90,100,110,120,130,140,150]

{"sheet":"cockpit calculation ISO 11812","index":2,"n_rows":151,"n_cols":21,"rows_kept":151,"hidden":true,"merged":[[2,1,2,6],[3,1,3,6],[49,0,49,11],[50,1,50,18],[61,0,61,11],[67,0,67,11],[68,0,68,1],[90,0,90,11],[91,0,91,1],[113,0,113,11],[126,0,126,6],[128,1,128,3],[129,0,133,0],[129,1,129,3],[129,4,129,6],[130,2,130,3],[130,5,130,6]]}
["Item rel. 0.1.1 / 12.09.07 UHU-Pro / vers. 2 dew 27.05.09",null,"Short Sign","Value","Unit","value range","ref. Clause","comment",null,"where to find on WS"]
[]
["Manufacturer",{"$f":"coverSheet!B5","v":0},{"$nulls":9},"listen"]
["model Designator",{"$f":"coverSheet!B12","v":0}]
[]
[null,"assessment date and shortsign"]
[{"$nulls":11},"Power"]
["Boat type",null,null,{"$f":"'Worksheet 1'!J7","v":0},null,"POWER, SAIL","3.1.2",{"$f":"IF(UPPER(D8) = \"POWER\", \"no comment\",(IF(D8 = \"SAIL\", \"no comment\", \"input boat type Power/Multi, Sail\")))","v":"input boat type Power/Multi, Sail"},{"$nulls":3},"Sail"]
[{"$nulls":7},{"$f":"IF(D8=\"\",\"Power = POWER\",\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(D8=\"\",\"Multihull = POWER\",\"\")","v":""},{"$nulls":3},"A"]
[null,null,{"$f":"IF(D8=\"SAIL\",\"As\",\" \")","v":" "},null,{"$f":"IF(D8=\"SAIL\",\"m²\",\" \")","v":" "},null,null,{"$f":"IF(D8=\"\",\"Mono Sail = SAIL\",\"\")","v":""},{"$nulls":3},"B"]
["Design Category intended",null,null,{"$f":"'Worksheet 1'!D7","v":0},null,"A, B, C, D",null,{"$f":"IF(AND((D12<>\"A\"),(D12<>\"B\"),(D12<>\"C\"),(D12<>\"D\")),\"input des. category type\",\"no comment\")","v":"input des. category type"},{"$nulls":3},"C"]
[{"$nulls":11},"D"]
["Cockpit","Cockpit bottom height","hb",{"$f":"IF('Worksheet 1'!I15=\"\",\"\",'Worksheet 1'!I15)","v":""},"m",{"$f":"IF(D14=\"\",\"\",IF(D14>D34,\"Pass\",\"Fail\"))","v":""},"3.16",{"$f":"IF(ISBLANK(D14),\"input optional\",\"\")","v":""}]
[null,"Cockpit water retention height","hc",{"$f":"'Worksheet 1'!I14","v":{"v":0,"d":"0.00"}},"m",null,"3.15",{"$f":"IF(ISBLANK(D15),\"input required\",\"\")","v":""}]
[null,"Length of hull","Lh",{"$f":"'Worksheet 1'!I10","v":{"v":0,"d":"0.00"}},"m","2,5 to 24","3.2, 3.15",{"$f":"IF(D16<2.5,\"out of range\",IF(D16>24,\"out of range\",\"no comment\"))","v":"out of range"}]
[null,"Beam of hull","Bh",{"$f":"'Worksheet 1'!I11","v":{"v":0,"d":"0.00"}},"m",null,null,{"$f":"IF(ISBLANK(D17),\"input required\",\"\")","v":""}]
[null,"Beam of hull (max)","Bmax",{"$f":"'Worksheet 1'!I11","v":{"v":0,"d":"0.00"}},"m",null,"3.3, 3.15",{"$f":"IF(ISBLANK(D18),\"input required\",\"\")","v":""}]
[null,"Freeboard amidships","Fm",{"$f":"'Worksheet 1'!I12","v":{"v":0,"d":"0.00"}},"m",null,"3.5, 3.28",{"$f":"IF(ISBLANK(D19),\"input required\",\"\")","v":""}]
[null,"Cockpit Volume","Vc",{"$f":"'Worksheet 1'!I13","v":{"v":0,"d":"0.00"}},"m³",null,"3.27",{"$f":"IF(ISBLANK(D20),\"Cockpit Volume (below Hc)\",\"\")","v":""}]
[{"$nulls":11},"none"]
["Drainage measurements","Draining section (crossarea)",null,null,"m²",null,"7.2",{"$f":"\"min area: \"&0.05*D20&\" m²\"","v":"min area: 0 m²"},{"$nulls":3},"without flaps"]
[null,"shape of the cross-section",{"$nulls":5},{"$f":"IF(D23=\"circular\",\"\",\"req. Min. 20mm & 500mm²\")","v":"req. Min. 20mm & 500mm²"}]
[null,"Number of drains",null,{"$f":"'Worksheet 1'!I17","v":0},"./.",null,null,"insert either diameter and ",null,null,"circular","with flaps"]
[null,"actual Drain diameter","d",{"$f":"'Worksheet 1'!I18","v":{"v":0,"d":"0.00"}},"mm",null,"7.8","number of drains or/ and",null,null,"other shapes"]
[null,"additionall openings (transom door, freeing port, u.a.)",null,{"$f":"'Worksheet 1'!I21","v":{"v":0,"d":"0.00"}},"mm²",null,"7.4.2","drainage area"]
[null,"freeing port with/without flaps",null,{"$f":"IF('Worksheet 1'!I22=\"\",\"\",'Worksheet 1'!I22)","v":""},null,"none, with flaps, without flaps",null,{"$f":"IF(ISBLANK(D27),\"input required\",\"\")","v":""}]
[null,"Drain with/without elbow",null,{"$f":"'Worksheet 1'!I19","v":{"v":0,"d":"0.00"}},null,"with, without",null,{"$f":"IF(ISBLANK(D28),\"input required\",\"\")","v":""},{"$nulls":3},"with"]
[null,"Drain below/above waterline",null,{"$f":"'Worksheet 1'!I20","v":{"v":0,"d":"0.00"}},null,"below, above",null,{"$f":"IF(ISBLANK(D29),\"input required\",\"\")","v":""},{"$nulls":3},"without"]
[null,"drain lenght",null,{"$f":"IF('Worksheet 1'!I16=\"\",\"\",'Worksheet 1'!I16)","v":""},"m",null,null,{"$f":"IF(ISBLANK(D30),\"input required\",\"\")","v":""}]
["Drainage requiremets","In upright Position",null,"98% of volume Vc (excluding any recess)",null,null,"7.1.2"]
[null,"In heeled Position",null,{"$f":"IF(D8=\"POWER\",\"At 10° heel, 90 % of Vc\",IF(D8=\"Sail\",\"At 30° heel deck side touches water 90% of Vc\",\"not defined\"))","v":"not defined"},null,null,"7.1.3",{"$nulls":4},"above"]
[{"$nulls":11},"below"]
["Results, general","minimum cockpit bottom height","hb, min",{"$f":"IF(D12=\"D\",0.05,IF(D12=\"C\",0.075,IF(D12=\"B\",0.1,IF(D12=\"A\",0.15,\"not defined\"))))","v":"not defined"},"m",null,"6.1"]
[null,"Draining time assessment (by section)",null,{"$f":"IF(D22>0.05*D20,\"not required\",\"required\")","v":"required"},"./.",null,"7.2"]
[null,"Cockpit volume coefficient","kc",{"$f":"IF(AND(D16>0,D18>0,D19>0),D20/D16/D18/D19,\"not defined\")","v":"not defined"},"./.",null,"3.28"]
[null,"Acceptable draininging time","t* max",{"$f":"IF(D36>0,IF(D12=\"A\",0.3/D36,IF(D12=\"B\",0.45/D36,IF(D12=\"C\",0.6/D36,IF(D12=\"D\",0.9/D36,\"not defined\")))),\"not defined\")","v":"not defined"},"min",null,"7.2, C.2"]
[null,"Acceptable draininging time, corr","t max",{"$f":"IF(D37>5,5,D37)","v":5},"min",null,"7.2, C.2",{"$f":"IF(D37>5,\"time corrected to 5 min\",\"\")","v":"time corrected to 5 min"}]
[null,"Reference time","t ref",{"$f":"IF(D20>0,D38/D20,0)","v":{"v":0,"d":"0.000"}},"min",null,"C.3"]
[{"$nulls":5},"tref /(C1C2) or tref /(C1C3)",{"$f":"D120","v":{"$error":"#N/A"}}]
["Results, drain requirements","drain diameter, required Table 4 value","d, min",{"$f":"IF(D27=\"\",'Table 4 calc'!E30,IF(D27<>\"none\",'Table 4 calc'!E36,'Table 4 calc'!E30))","v":false}]
[null,"drain diameter, exact value with Cx","d, min",{"$f":"IF(AND(D30<>\"\",D15<>\"\"),'Table C2'!H18,D41)","v":false},"mm",null,"7.4.1",null,"take value from table 4 (two drains)"]
[null,"rectangular cross section, required","A, min",{"$f":"(D42/2)^2*PI()*2","v":0},"mm²","at least 20 mm in one dimension"]
[null,"Protective grids, total cross section, minimum",null,{"$f":"1.5*D25*D25/4*3.14152","v":0},"mm²"]
[{"$nulls":5},"C1 ",{"$f":"D66","v":{"$error":"#N/A"}}]
["actual","actual rectangular cross section","A",{"$f":"IF(D42=\"\",\"\",(D25/2)^2*PI()*D24+D26)","v":0},"mm²","C2 ",{"$f":"IF(D89<>\"\",D89,\"\")","v":""},{"$f":"IF(D42=\"\",\"fill in req. Drain diameter\",\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(D46>=D43, \"requirements fulfilled, PASS\", \"FAIL\")","v":"requirements fulfilled, PASS"},null,"C3 ",{"$f":"IF(D112<>\"\",D112,\"\")","v":""}]
[]
[]
["Table 4 — Drain diameter as a function of tref and typical drain arrangement"]
["Typical drain arrangement","Values of tref (min)"]
["Drain outlet above WL, no elbow",8.8,5.8,4.1,3,2.3,1.8,1.5,1.2,1,0.9,0.8,0.7,0.5,0.4,0.3,0.3,0.2,0.2,0.2]
["Drain outlet above WL, two elbows",10,6.7,4.7,3.5,2.7,2.2,1.8,1.5,1.3,1.1,0.9,0.8,0.6,0.5,0.4,0.4,0.3,0.3,0.2]
["Drain outlet below WL, no elbow",10.8,7.2,5.1,3.9,3,2.4,2,1.6,1.4,1.2,1,0.9,0.7,0.6,0.5,0.4,0.3,0.3,0.2]
["Drain outlet below WL, two elbows",11.8,7.9,5.7,4.3,3.3,2.7,2.2,1.8,1.5,1.3,1.2,1,0.8,0.6,0.5,0.4,0.4,0.3,0.3]
["Freeing port above WL, no flap",10.1,7,5.2,3.9,3.1,2.5,2.1,1.8,1.5,1.3,1.1,1,0.8,0.6,0.5,0.4,0.4,0.3,0.3]
["Freeings port above WL, with flap",15.2,10.5,7.7,5.9,4.7,3.8,3.1,2.6,2.2,1.9,1.7,1.5,1.2,0.9,0.8,0.7,0.6,0.5,0.4]
["Drain diameter d (mm) two drains",25,30,35,40,45,50,55,60,65,70,75,80,90,100,110,120,130,140,150]
[]
[]
[]
["Table C.1 — Values of C1 as a function of h"]
["hC (m)",0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1,1.1,1.2,1.3,1.4,1.5,1.6,1.7,1.8,1.9,2]
["C1 = (t1,hC/t1,04)",0.83,0.98,1,0.99,0.97,0.94,0.91,0.89,0.86,0.84,0.82,0.8,0.78,0.77,0.75,0.73,0.72,0.71,0.69]
[]
[null,null,"C1 ",{"$f":"'Koeffient C1'!H44","v":{"$error":"#N/A"}},{"$nulls":3},"automatical calculation ; please check"]
[]
["Table C.3 — Values of C2 for hC = 0,4 m and drain outlet above the waterline"]
["Drain lengthL (m)",null,0.2,0.4,0.6,0.8,1,1.2]
["Drain",25,1.1,1.18,1.25,1.32,1.38,1.45]
[null,30,1.09,1.15,1.21,1.26,1.31,1.37]
["diameter",35,1.08,1.13,1.18,1.22,1.27,1.31]
[null,40,1.07,1.11,1.15,1.19,1.23,1.27]
["d (mm) =",45,1.07,1.1,1.14,1.17,1.21,1.24]
[null,50,1.06,1.09,1.12,1.15,1.18,1.21]
[null,55,1.06,1.09,1.11,1.14,1.17,1.19]
[null,60,1.05,1.08,1.11,1.13,1.15,1.18]
[null,65,1.05,1.08,1.1,1.12,1.14,1.16]
[null,70,1.05,1.07,1.09,1.11,1.13,1.12]
[null,80,1.05,1.06,1.08,1.1,1.12,1.13]
[null,90,1.04,1.06,1.08,1.09,1.11,1.12]
[null,100,1.04,1.06,1.07,1.08,1.1,1.11]
[null,110,1.04,1.05,1.07,1.08,1.09,1.1]
[null,120,1.04,1.05,1.06,1.08,1.08,1.09]
[null,130,1.04,1.05,1.06,1.07,1.08,1.09]
[null,140,1.04,1.05,1.06,1.07,1.07,1.08]
[null,150,1.04,1.05,1.05,1.06,1.07,1.08]
[]
[null,null,"C2 ",{"$f":"IF(D29=\"above\",'Koef. C2 Table C3'!E24,\"\")","v":""},{"$nulls":3},"automatical calculation ; please check"]
[]
["Table C.4 — Values of C3 for hC = 0,4 m and drain outlet below the waterline"]
["Drain length L (m)",null,0.2,0.4,0.6,0.8,1,1.2]
["Drain",25,1.49,1.55,1.61,1.67,1.72,1.77]
[null,30,1.48,1.53,1.57,1.62,1.66,1.71]
["diameter",35,1.47,1.51,1.55,1.59,1.63,1.69]
[null,40,1.47,1.5,1.53,1.57,1.6,1.63]
["d (mm) =",45,1.46,1.49,1.52,1.55,1.58,1.6]
[null,50,1.46,1.49,1.51,1.53,1.56,1.58]
[null,55,1.46,1.48,1.5,1.52,1.54,1.57]
[null,60,1.46,1.47,1.49,1.51,1.53,1.55]
[null,65,1.45,1.47,1.49,1.51,1.52,1.54]
[null,70,1.45,1.47,1.48,1.5,1.52,1.53]
[null,80,1.45,1.46,1.48,1.49,1.5,1.52]
[null,90,1.45,1.46,1.47,1.48,1.49,1.51]
[null,100,1.45,1.46,1.47,1.48,1.49,1.5]
[null,110,1.44,1.45,1.46,1.47,1.48,1.49]
[null,120,1.44,1.45,1.46,1.47,1.48,1.49]
[null,130,1.44,1.45,1.46,1.47,1.48,1.49]
[null,140,1.44,1.45,1.46,1.46,1.47,1.48]
[null,150,1.44,1.45,1.45,1.46,1.47,1.47]
[]
[null,null,"C3 ",{"$f":"IF(D29=\"below\",'Koef. C3 Table C4'!E24,\"\")","v":""},{"$nulls":3},"automatical calculation ; please check"]
[]
["Table C.2 — Drain diameter as a function of tref /(C1C2) of tref /(C1C3)"]
["tref /(C1C2) or tref /(C1C3)",9.47,6.06,4.21,3.09,2.37,1.87,1.52,1.25,1.05,0.9,0.77,0.67,0.59,0.47,0.38,0.31,0.26,0.22,0.19,0.17]
["Drain diameter (mm)",20,25,30,35,40,45,50,55,60,65,70,75,80,90,100,110,120,130,140,150]
["Drain section (cm2)",3,5,7,10,13,16,20,24,28,33,38,44,50,64,79,95,113,133,154,177]
[]
[]
[null,"tref /(C1C2) or tref /(C1C3)",null,{"$f":"IF(D66=\"\",\"\",IF(D89<>\"\",D39/D66/D89,D39/D66/D112))","v":{"$error":"#N/A"}}]
[]
["Results, drain requirements","circular cross section, required","d, min",{"$f":"'Table C2'!H18","v":{"$error":"#N/A"}},"mm",null,null,"automatical calculation ; please check"]
[null,"rectangular cross section, required","A, min",{"$f":"(D122/2)^2*PI()*2","v":{"$error":"#N/A"}},"mm²"]
[null,null,{"$f":"IF(D46>=D123, \"requirements fulfilled, PASS\", \"FAIL\")","v":{"$error":"#N/A"}}]
["Requirements sill height"]
[]
["Table 5 — Minimum values hS,min for fixed sills and semi-fixed sills"]
[]
[null,"dimensions in m"]
["Design Category","Sailing monohulls",null,null,"Non-sailing boats and sailing multihulls"]
[null,"Fixed sill","Semi-fixed sill",null,"Fixed sill","Semi-fixed sill"]
[null,"Top of sill","Top of fixed part","Top of mobile part","Top of sill","Top of fixed part","Top of mobile part"]
[]
[null,"hS,min","hS,min/2","hS,min","hS,min","hS,min/2","hS,min"]
["A",0.3,0.15,0.3,0.2,0.1,0.2]
["B",0.25,0.125,0.25,0.15,0.075,0.15]
["C",0.15,0.075,0.15,0.1,0.05,0.1]
["D",0.05,0.025,0.05,0.05,0.025,0.05]
[]
[]
["Cockpit","actual height of fixed sill","hS/2",{"$f":"'Worksheet 1'!I23","v":{"v":0,"d":"0.00"}},"m"]
[]
[null,"required height of fixed sill","hS,min/2",{"$f":"IF(D8=\"power\",LOOKUP(D12,A135:A138,F135:F138),IF(AND(D8=\"sail\",'Worksheet 1'!H7=\"Multihull\"),LOOKUP(D12,A135:A138,F135:F138),LOOKUP(D12,A135:A138,C135:C138)))","v":{"$error":"#N/A"}},"m"]
[]
[null,null,{"$f":"IF(D141>=D143, \"requirements fulfilled, PASS\", \"FAIL\")","v":{"$error":"#N/A"}}]
[]
[null,"semifixed sill heigh mobile part","hS,min",{"$f":"'Worksheet 1'!I24","v":{"v":0,"d":"0.00"}},"m"]
[]
[null,"required height of semifixed sill heigh part","hS,min",{"$f":"IF(D8=\"Power\",LOOKUP(D12,A135:A138,G135:G138),IF(AND(D8=\"sail\",'Worksheet 1'!H7=\"Multihull\"),LOOKUP(D12,A135:A138,G135:G138),LOOKUP(D12,A135:A138,D135:D138)))","v":{"$error":"#N/A"}},"m"]
[]
[null,null,{"$f":"IF(D147>=D149, \"requirements fulfilled, PASS\", \"FAIL\")","v":{"$error":"#N/A"}}]

{"sheet":"Table 4 calc","index":3,"n_rows":39,"n_cols":18,"rows_kept":39,"hidden":true,"merged":[[3,0,21,0],[25,2,26,2]]}
[{"$nulls":10},"Transponierte Tabelle für Abfrage"]
[]
["Typical drain arrangement",null,"Drain outlet above WL, no elbow","Drain outlet above WL, two elbows","Drain outlet below WL, no elbow","Drain outlet below WL, two elbows","Freeing port above WL, no flap","Freeings port above WL, with flap","Drain diameter d (mm) two drains",null,null,"Drain outlet above WL, no elbow","Drain outlet above WL, two elbows","Drain outlet below WL, no elbow","Drain outlet below WL, two elbows","Freeing port above WL, no flap","Freeings port above WL, with flap","Drain diameter d (mm) two drains"]
["Values of tref (min)",{"$nulls":10},0.1,0.1,0.1,0.25,0.25,0.3,160]
[null,25,8.8,10,10.8,11.8,10.1,15.2,25,null,null,0.2,0.2,0.2,0.3,0.3,0.4,150]
[null,30,5.8,6.7,7.2,7.9,7,10.5,30,null,null,0.2,0.3,0.3,0.3,0.3,0.5,140]
[null,35,4.1,4.7,5.1,5.7,5.2,7.7,35,null,null,0.2,0.3,0.3,0.4,0.4,0.6,130]
[null,40,3,3.5,3.9,4.3,3.9,5.9,40,null,null,0.3,0.4,0.4,0.4,0.4,0.7,120]
[null,45,2.3,2.7,3,3.3,3.1,4.7,45,null,null,0.3,0.4,0.5,0.5,0.5,0.8,110]
[null,50,1.8,2.2,2.4,2.7,2.5,3.8,50,null,null,0.4,0.5,0.6,0.6,0.6,0.9,100]
[null,55,1.5,1.8,2,2.2,2.1,3.1,55,null,null,0.5,0.6,0.7,0.8,0.8,1.2,90]
[null,60,1.2,1.5,1.6,1.8,1.8,2.6,60,null,null,0.7,0.8,0.9,1,1,1.5,80]
[null,65,1,1.3,1.4,1.5,1.5,2.2,65,null,null,0.8,0.9,1,1.2,1.1,1.7,75]
[null,70,0.9,1.1,1.2,1.3,1.3,1.9,70,null,null,0.9,1.1,1.2,1.3,1.3,1.9,70]
[null,75,0.8,0.9,1,1.2,1.1,1.7,75,null,null,1,1.3,1.4,1.5,1.5,2.2,65]
[null,80,0.7,0.8,0.9,1,1,1.5,80,null,null,1.2,1.5,1.6,1.8,1.8,2.6,60]
[null,90,0.5,0.6,0.7,0.8,0.8,1.2,90,null,null,1.5,1.8,2,2.2,2.1,3.1,55]
[null,100,0.4,0.5,0.6,0.6,0.6,0.9,100,null,null,1.8,2.2,2.4,2.7,2.5,3.8,50]
[null,110,0.3,0.4,0.5,0.5,0.5,0.8,110,null,null,2.3,2.7,3,3.3,3.1,4.7,45]
[null,120,0.3,0.4,0.4,0.4,0.4,0.7,120,null,null,3,3.5,3.9,4.3,3.9,5.9,40]
[null,130,0.2,0.3,0.3,0.4,0.4,0.6,130,null,null,4.1,4.7,5.1,5.7,5.2,7.7,35]
[null,140,0.2,0.3,0.3,0.3,0.3,0.5,140,null,null,5.8,6.7,7.2,7.9,7,10.5,30]
[null,150,0.2,0.2,0.2,0.3,0.3,0.4,150,null,null,8.8,10,10.8,11.8,10.1,15.2,25]
[{"$nulls":11},"min 25mm","min 25mm","min 25mm","min 25mm","min 25mm","min 25mm"]
[]
[null,null,"above?\nbelow?"]
[null,"tref",null,"elbows?","freeing port"]
[null,{"$f":"'cockpit calculation ISO 11812'!D39","v":{"v":0,"d":"0.00000"}},{"$f":"'cockpit calculation ISO 11812'!D29","v":0},{"$f":"'cockpit calculation ISO 11812'!D28","v":0},{"$f":"'cockpit calculation ISO 11812'!D27","v":""}]
[]
[null,"erste Näherung Table 4 value",null,null,{"$f":"IF(B28<>\"\",IF(AND(C28<>\"\",D28<>\"\"),IF(AND(D28=\"without\",C28=\"below\"),LOOKUP($B$28,N4:N23,R4:R23),IF(AND(D28=\"with\",C28=\"below\"),LOOKUP($B$28,O4:O23,R4:R23),IF(AND(C28=\"above\",D28=\"without\"),LOOKUP($B$28,L4:L23,R4:R23),IF(AND(C28=\"above\",D28=\"with\"),LOOKUP($B$28,M4:M23,R4:R23)))))),\"\")","v":false},null,"geht auf den größeren Durchmesserwert"]
[null,"Drains",{"$nulls":3},{"$f":"IF(E30=25,25,IF(E30<=80,E30-5,E30-10))","v":-10},"der nächst kleinere Durchmesser"]
[{"$nulls":5},{"$f":"IF(B28<>\"\",IF(AND(C28<>\"\",D28<>\"\"),IF(AND(D28=\"without\",C28=\"below\"),LOOKUP($B$28,N4:N23,N5:N24),IF(AND(D28=\"with\",C28=\"below\"),LOOKUP($B$28,O4:O23,O5:O24),IF(AND(C28=\"above\",D28=\"without\"),LOOKUP($B$28,L4:L23,L5:L24),IF(AND(C28=\"above\",D28=\"with\"),LOOKUP($B$28,M4:M23,M5:M24)))))),\"\")","v":false},"suche nächsten größeren Tabellenwert tref"]
[{"$nulls":5},{"$f":"IF(B28<>\"\",IF(AND(C28<>\"\",D28<>\"\"),IF(AND(D28=\"without\",C28=\"below\"),LOOKUP($B$28,N4:N23,N4:N23),IF(AND(D28=\"with\",C28=\"below\"),LOOKUP($B$28,O4:O23,O4:O23),IF(AND(C28=\"above\",D28=\"without\"),LOOKUP($B$28,L4:L23,L4:L23),IF(AND(C28=\"above\",D28=\"with\"),LOOKUP($B$28,M4:M23,M4:M23)))))),\"\")","v":false},"suche nächsten kleineren Tabellenwert tref"]
[]
[null,"erste Näherung Table 4 value"]
[null,"freeing ports",null,null,{"$f":"IF(B28<>\"\",IF(E28=\"without flaps\",LOOKUP($B$28,P4:P23,R4:R23),IF(E28=\"with flaps\",LOOKUP($B$28,Q4:Q23,R4:R23),\"no freeing ports\")),\"\")","v":"no freeing ports"},null,"geht auf den größeren Durchmesserwert"]
[{"$nulls":5},{"$f":"IF(E36=25,25,IF(E36<=80,E36-5,E36-10))","v":{"$error":"#VALUE!"}},"der nächst kleinere Durchmesser"]
[{"$nulls":5},{"$f":"IF(B28<>\"\",IF(E28=\"without flaps\",LOOKUP($B$28,P4:P23,P5:P24),IF(E28=\"with flaps\",LOOKUP($B$28,Q4:Q23,Q5:Q24),\"no freeing ports\")),\"\")","v":"no freeing ports"},"suche nächsten größeren Tabellenwert tref"]
[{"$nulls":5},{"$f":"IF(B28<>\"\",IF(E28=\"without flaps\",LOOKUP($B$28,P4:P23,P4:P23),IF(E28=\"with flaps\",LOOKUP($B$28,Q4:Q23,Q4:Q23),\"no freeing ports\")),\"\")","v":"no freeing ports"},"suche nächsten kleineren Tabellenwert tref"]

{"sheet":"Koeffient C1","index":5,"n_rows":224,"n_cols":20,"rows_kept":224,"hidden":true,"merged":[[27,1,27,12]]}
["hc","C1"]
[{"v":0.2,"d":"0.20"},0.83]
[{"v":0.3,"d":"0.30"},0.98]
[{"v":0.4,"d":"0.40"},{"v":1,"d":"1.00"}]
[{"v":0.5,"d":"0.50"},0.99]
[{"v":0.6,"d":"0.60"},0.97]
[{"v":0.7,"d":"0.70"},0.94]
[{"v":0.8,"d":"0.80"},0.91]
[{"v":0.9,"d":"0.90"},0.89]
[{"v":1,"d":"1.00"},0.86]
[{"v":1.1,"d":"1.10"},0.84]
[{"v":1.2,"d":"1.20"},0.82]
[{"v":1.3,"d":"1.30"},{"v":0.8,"d":"0.80"}]
[{"v":1.4,"d":"1.40"},0.78]
[{"v":1.5,"d":"1.50"},0.77]
[{"v":1.6,"d":"1.60"},0.75]
[{"v":1.7,"d":"1.70"},0.73]
[{"v":1.8,"d":"1.80"},0.72]
[{"v":1.9,"d":"1.90"},0.71]
[{"v":2,"d":"2.00"},0.69]
{"$rows_empty":7}
[null,"Table C.1 — Values of C1 as a function of h"]
[]
["hC (m)",0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1,1.1,1.2,1.3,1.4,1.5,1.6,1.7,1.8,1.9,2]
["C1 = (t1,hC/t1,04)",0.83,0.98,1,0.99,0.97,0.94,0.91,0.89,0.86,0.84,0.82,0.8,0.78,0.77,0.75,0.73,0.72,0.71,0.69]
[]
[null,"hC (m)","C1 = (t1,hC/t1,04)",{"$nulls":3},"hc =","Koef. C1 ="]
[null,0.0999999999999999,0.83]
[null,0.11,0.83]
[null,0.12,0.83]
[null,0.13,0.83]
[null,0.14,0.83]
[null,0.15,0.83]
[null,0.16,0.83]
[null,0.17,0.83]
[null,0.18,0.83]
[null,0.19,0.83]
[null,0.2,0.83,{"$nulls":3},{"$f":"'cockpit calculation ISO 11812'!D15","v":0},{"$f":"LOOKUP(G44,B34:B224,C34:C224)","v":{"$error":"#N/A"}}]
[null,0.21,{"$f":"C44+D45","v":0.845},{"$f":"(C54-C44)/10","v":0.015000000000000003}]
[null,0.22,{"$f":"C45+D45","v":0.86}]
[null,0.23,{"$f":"C46+D45","v":0.875}]
[null,0.24,{"$f":"C47+D45","v":0.89}]
[null,0.25,{"$f":"C48+D45","v":0.905}]
[null,0.26,{"$f":"C49+D45","v":0.92}]
[null,0.27,{"$f":"C50+D45","v":0.935}]
[null,0.28,{"$f":"C51+D45","v":0.9500000000000001}]
[null,0.29,{"$f":"C52+D45","v":0.9650000000000001}]
[null,0.3,0.98]
[null,0.31,{"$f":"C54+D55","v":0.982},{"$f":"(C64-C54)/10","v":2.0000000000000018E-3}]
[null,0.32,{"$f":"C55+D55","v":0.984}]
[null,0.33,{"$f":"C56+D55","v":0.986}]
[null,0.34,{"$f":"C57+D55","v":0.988}]
[null,0.35,{"$f":"C58+D55","v":0.99}]
[null,0.36,{"$f":"C59+D55","v":0.992}]
[null,0.37,{"$f":"C60+D55","v":0.994}]
[null,0.38,{"$f":"C61+D55","v":0.996}]
[null,0.39,{"$f":"C62+D55","v":0.998}]
[null,0.4,1]
[null,0.41,{"$f":"C64+D65","v":0.999},{"$f":"(C74-C64)/10","v":-1.0000000000000009E-3}]
[null,0.42,{"$f":"C65+D65","v":0.998}]
[null,0.43,{"$f":"C66+D65","v":0.997}]
[null,0.44,{"$f":"C67+D65","v":0.996}]
[null,0.45,{"$f":"C68+D65","v":0.995}]
[null,0.46,{"$f":"C69+D65","v":0.994}]
[null,0.47,{"$f":"C70+D65","v":0.993}]
[null,0.48,{"$f":"C71+D65","v":0.992}]
[null,0.49,{"$f":"C72+D65","v":0.991}]
[null,0.5,0.99]
[null,0.51,{"$f":"C74+D75","v":0.988},{"$f":"(C84-C74)/10","v":-2.0000000000000018E-3}]
[null,0.52,{"$f":"C75+D75","v":0.986}]
[null,0.53,{"$f":"C76+D75","v":0.984}]
[null,0.54,{"$f":"C77+D75","v":0.982}]
[null,0.55,{"$f":"C78+D75","v":0.98}]
[null,0.56,{"$f":"C79+D75","v":0.978}]
[null,0.57,{"$f":"C80+D75","v":0.976}]
[null,0.58,{"$f":"C81+D75","v":0.974}]
[null,0.59,{"$f":"C82+D75","v":0.972}]
[null,0.6,0.97]
[null,0.61,{"$f":"C84+D85","v":0.967},{"$f":"(C94-C84)/10","v":-3.0000000000000027E-3}]
[null,0.62,{"$f":"C85+D85","v":0.964}]
[null,0.63,{"$f":"C86+D85","v":0.961}]
[null,0.64,{"$f":"C87+D85","v":0.958}]
[null,0.65,{"$f":"C88+D85","v":0.955}]
[null,0.66,{"$f":"C89+D85","v":0.952}]
[null,0.67,{"$f":"C90+D85","v":0.949}]
[null,0.68,{"$f":"C91+D85","v":0.946}]
[null,0.69,{"$f":"C92+D85","v":0.943}]
[null,0.7,0.94]
[null,0.71,{"$f":"C94+D95","v":0.9369999999999999},{"$f":"(C104-C94)/10","v":-2.9999999999999914E-3}]
[null,0.72,{"$f":"C95+D95","v":0.9339999999999999}]
[null,0.73,{"$f":"C96+D95","v":0.9309999999999999}]
[null,0.74,{"$f":"C97+D95","v":0.9279999999999999}]
[null,0.75,{"$f":"C98+D95","v":0.9249999999999999}]
[null,0.76,{"$f":"C99+D95","v":0.9219999999999999}]
[null,0.77,{"$f":"C100+D95","v":0.9189999999999999}]
[null,0.78,{"$f":"C101+D95","v":0.9159999999999999}]
[null,0.79,{"$f":"C102+D95","v":0.9129999999999999}]
[null,0.8,0.91]
[null,0.81,{"$f":"C104+D105","v":0.908},{"$f":"(C114-C104)/10","v":-2.0000000000000018E-3}]
[null,0.82,{"$f":"C105+D105","v":0.906}]
[null,0.83,{"$f":"C106+D105","v":0.904}]
[null,0.84,{"$f":"C107+D105","v":0.902}]
[null,0.85,{"$f":"C108+D105","v":0.9}]
[null,0.860000000000001,{"$f":"C109+D105","v":0.898}]
[null,0.870000000000001,{"$f":"C110+D105","v":0.896}]
[null,0.880000000000001,{"$f":"C111+D105","v":0.894}]
[null,0.890000000000001,{"$f":"C112+D105","v":0.892}]
[null,0.900000000000001,0.89]
[null,0.910000000000001,{"$f":"C114+D115","v":0.887},{"$f":"(C124-C114)/10","v":-3.0000000000000027E-3}]
[null,0.920000000000001,{"$f":"C115+D115","v":0.884}]
[null,0.930000000000001,{"$f":"C116+D115","v":0.881}]
[null,0.940000000000001,{"$f":"C117+D115","v":0.878}]
[null,0.950000000000001,{"$f":"C118+D115","v":0.875}]
[null,0.960000000000001,{"$f":"C119+D115","v":0.872}]
[null,0.970000000000001,{"$f":"C120+D115","v":0.869}]
[null,0.980000000000001,{"$f":"C121+D115","v":0.866}]
[null,0.990000000000001,{"$f":"C122+D115","v":0.863}]
[null,1,0.86]
[null,1.01,{"$f":"C124+D125","v":0.858},{"$f":"(C134-C124)/10","v":-2.0000000000000018E-3}]
[null,1.02,{"$f":"C125+D125","v":0.856}]
[null,1.03,{"$f":"C126+D125","v":0.854}]
[null,1.04,{"$f":"C127+D125","v":0.852}]
[null,1.05,{"$f":"C128+D125","v":0.85}]
[null,1.06,{"$f":"C129+D125","v":0.848}]
[null,1.07,{"$f":"C130+D125","v":0.846}]
[null,1.08,{"$f":"C131+D125","v":0.844}]
[null,1.09,{"$f":"C132+D125","v":0.842}]
[null,1.1,0.84]
[null,1.11,{"$f":"C134+D135","v":0.838},{"$f":"(C144-C134)/10","v":-2.0000000000000018E-3}]
[null,1.12,{"$f":"C135+D135","v":0.836}]
[null,1.13,{"$f":"C136+D135","v":0.834}]
[null,1.14,{"$f":"C137+D135","v":0.832}]
[null,1.15,{"$f":"C138+D135","v":0.83}]
[null,1.16,{"$f":"C139+D135","v":0.828}]
[null,1.17,{"$f":"C140+D135","v":0.826}]
[null,1.18,{"$f":"C141+D135","v":0.824}]
[null,1.19,{"$f":"C142+D135","v":0.822}]
[null,1.2,0.82]
[null,1.21,{"$f":"C144+D145","v":0.818},{"$f":"(C154-C144)/10","v":-1.9999999999999905E-3}]
[null,1.22,{"$f":"C145+D145","v":0.816}]
[null,1.23,{"$f":"C146+D145","v":0.814}]
[null,1.24,{"$f":"C147+D145","v":0.8119999999999999}]
[null,1.25,{"$f":"C148+D145","v":0.8099999999999999}]
[null,1.26,{"$f":"C149+D145","v":0.8079999999999999}]
[null,1.27,{"$f":"C150+D145","v":0.8059999999999999}]
[null,1.28,{"$f":"C151+D145","v":0.8039999999999999}]
[null,1.29,{"$f":"C152+D145","v":0.8019999999999999}]
[null,1.3,0.8]
[null,1.31,{"$f":"C154+D155","v":0.798},{"$f":"(C164-C154)/10","v":-2.0000000000000018E-3}]
[null,1.32,{"$f":"C155+D155","v":0.796}]
[null,1.33,{"$f":"C156+D155","v":0.794}]
[null,1.34,{"$f":"C157+D155","v":0.792}]
[null,1.35,{"$f":"C158+D155","v":0.79}]
[null,1.36,{"$f":"C159+D155","v":0.788}]
[null,1.37,{"$f":"C160+D155","v":0.786}]
[null,1.38,{"$f":"C161+D155","v":0.784}]
[null,1.39,{"$f":"C162+D155","v":0.782}]
[null,1.4,0.78]
[null,1.41,{"$f":"C164+D165","v":0.779},{"$f":"(C174-C164)/10","v":-1.0000000000000009E-3}]
[null,1.42,{"$f":"C165+D165","v":0.778}]
[null,1.43,{"$f":"C166+D165","v":0.777}]
[null,1.44,{"$f":"C167+D165","v":0.776}]
[null,1.45,{"$f":"C168+D165","v":0.775}]
[null,1.46,{"$f":"C169+D165","v":0.774}]
[null,1.47,{"$f":"C170+D165","v":0.773}]
[null,1.48,{"$f":"C171+D165","v":0.772}]
[null,1.49,{"$f":"C172+D165","v":0.771}]
[null,1.5,0.77]
[null,1.51,{"$f":"C174+D175","v":0.768},{"$f":"(C184-C174)/10","v":-2.0000000000000018E-3}]
[null,1.52,{"$f":"C175+D175","v":0.766}]
[null,1.53,{"$f":"C176+D175","v":0.764}]
[null,1.54,{"$f":"C177+D175","v":0.762}]
[null,1.55,{"$f":"C178+D175","v":0.76}]
[null,1.56,{"$f":"C179+D175","v":0.758}]
[null,1.57,{"$f":"C180+D175","v":0.756}]
[null,1.58,{"$f":"C181+D175","v":0.754}]
[null,1.59,{"$f":"C182+D175","v":0.752}]
[null,1.6,0.75]
[null,1.61,{"$f":"C184+D185","v":0.748},{"$f":"(C194-C184)/10","v":-2.0000000000000018E-3}]
[null,1.62,{"$f":"C185+D185","v":0.746}]
[null,1.63,{"$f":"C186+D185","v":0.744}]
[null,1.64,{"$f":"C187+D185","v":0.742}]
[null,1.65,{"$f":"C188+D185","v":0.74}]
[null,1.66,{"$f":"C189+D185","v":0.738}]
[null,1.67,{"$f":"C190+D185","v":0.736}]
[null,1.68,{"$f":"C191+D185","v":0.734}]
[null,1.69,{"$f":"C192+D185","v":0.732}]
[null,1.7,0.73]
[null,1.71,{"$f":"C194+D195","v":0.729},{"$f":"(C204-C194)/10","v":-1.0000000000000009E-3}]
[null,1.72,{"$f":"C195+D195","v":0.728}]
[null,1.73,{"$f":"C196+D195","v":0.727}]
[null,1.74,{"$f":"C197+D195","v":0.726}]
[null,1.75,{"$f":"C198+D195","v":0.725}]
[null,1.76,{"$f":"C199+D195","v":0.724}]
[null,1.77,{"$f":"C200+D195","v":0.723}]
[null,1.78,{"$f":"C201+D195","v":0.722}]
[null,1.79,{"$f":"C202+D195","v":0.721}]
[null,1.8,0.72]
[null,1.81,{"$f":"C204+D205","v":0.719},{"$f":"(C214-C204)/10","v":-1.0000000000000009E-3}]
[null,1.82,{"$f":"C205+D205","v":0.718}]
[null,1.83,{"$f":"C206+D205","v":0.717}]
[null,1.84,{"$f":"C207+D205","v":0.716}]
[null,1.85,{"$f":"C208+D205","v":0.715}]
[null,1.86,{"$f":"C209+D205","v":0.714}]
[null,1.87,{"$f":"C210+D205","v":0.713}]
[null,1.88,{"$f":"C211+D205","v":0.712}]
[null,1.89,{"$f":"C212+D205","v":0.711}]
[null,1.9,0.71]
[null,1.91,{"$f":"C214+D215","v":0.708},{"$f":"(C224-C214)/10","v":-2.0000000000000018E-3}]
[null,1.92,{"$f":"C215+D215","v":0.706}]
[null,1.93,{"$f":"C216+D215","v":0.704}]
[null,1.94,{"$f":"C217+D215","v":0.702}]
[null,1.95,{"$f":"C218+D215","v":0.7}]
[null,1.96,{"$f":"C219+D215","v":0.698}]
[null,1.97,{"$f":"C220+D215","v":0.696}]
[null,1.98,{"$f":"C221+D215","v":0.694}]
[null,1.99,{"$f":"C222+D215","v":0.692}]
[null,2,0.69]

{"sheet":"C10","index":6,"n_rows":20,"n_cols":5,"rows_kept":20,"hidden":true}
[null,"hc","C1"]
[1,{"v":0.2,"d":"0.20"},0.83,{"$f":"(0.000005*B2*B2*B2*B2*B2)-(0.0003*B2^4)+(0.0063*B2^3)-(0.0627*B2^2)+(0.2559*B2)+0.6457","v":{"v":0.6944219216,"d":"0.69442"}},{"$f":"(0.000005*A2*A2*A2*A2*A2)-(0.0003*A2^4)+(0.0063*A2^3)-(0.0627*A2^2)+(0.2559*A2)+0.6457","v":{"v":0.844905,"d":"0.84491"}}]
[2,{"v":0.3,"d":"0.30"},0.98,{"$f":"(0.000005*B3*B3*B3*B3*B3)-(0.0003*B3^4)+(0.0063*B3^3)-(0.0627*B3^2)+(0.2559*B3)+0.6457","v":{"v":0.7169946821500001,"d":"0.71699"}},{"$f":"(0.000005*A3*A3*A3*A3*A3)-(0.0003*A3^4)+(0.0063*A3^3)-(0.0627*A3^2)+(0.2559*A3)+0.6457","v":{"v":0.9524600000000001,"d":"0.95246"}}]
[3,{"v":0.4,"d":"0.40"},{"v":1,"d":"1.00"},{"v":0.7384235712,"d":"0.73842"},{"v":0.9961150000000001,"d":"0.99612"}]
[4,{"v":0.5,"d":"0.50"},0.99,{"v":0.7587439062500001,"d":"0.75874"},{"v":0.9976200000000001,"d":"0.99762"}]
[5,{"v":0.6,"d":"0.60"},0.97,{"v":0.7779903088000001,"d":"0.77799"},{"v":0.973325,"d":"0.97333"}]
[6,{"v":0.7,"d":"0.70"},0.94,{"v":0.7961967103500001,"d":"0.79620"},0.93478]
[7,{"v":0.8,"d":"0.80"},0.91,{"v":0.8133963584,"d":"0.81340"},{"v":0.8893349999999999,"d":"0.88934"}]
[8,{"v":0.9,"d":"0.90"},0.89,{"v":0.82962182245,"d":"0.82962"},{"v":0.8407399999999997,"d":"0.84074"}]
[9,{"v":1,"d":"1.00"},0.86,{"v":0.844905,"d":"0.84491"},{"v":0.7897449999999998,"d":"0.78975"}]
[10,{"v":1.1,"d":"1.10"},0.84,{"v":0.85927712255,"d":"0.85928"},{"v":0.7347,"d":"0.73470"}]
[11,{"v":1.2,"d":"1.20"},0.82,{"v":0.8727687616,"d":"0.87277"},{"v":0.6721550000000008,"d":"0.67216"}]
[12,{"v":1.3,"d":"1.30"},{"v":0.8,"d":"0.80"},{"v":0.8854098346500001,"d":"0.88541"},{"v":0.5974600000000002,"d":"0.59746"}]
[13,{"v":1.4,"d":"1.40"},0.78,{"v":0.8972296112,"d":"0.89723"},{"v":0.5053650000000011,"d":"0.50537"}]
[14,{"v":1.5,"d":"1.50"},0.77,{"v":0.9082567187500001,"d":"0.90826"},{"v":0.39061999999999963,"d":"0.39062"}]
[15,{"v":1.6,"d":"1.60"},0.75,{"v":0.9185191488000001,"d":"0.91852"},{"v":0.24857500000000143,"d":"0.24858"}]
[16,{"v":1.7,"d":"1.70"},0.73,{"v":0.9280442628500001,"d":"0.92804"},{"v":0.07578000000000029,"d":"0.07578"}]
[17,{"v":1.8,"d":"1.80"},0.72,{"v":0.9368587984000001,"d":"0.93686"},{"v":-0.1294149999999924,"d":"-0.12941"}]
[18,{"v":1.9,"d":"1.90"},0.71,{"v":0.9449888749500001,"d":"0.94499"},{"v":-0.36625999999999925,"d":"-0.36626"}]
[19,{"v":2,"d":"2.00"},0.69,{"v":0.9524600000000001,"d":"0.95246"},{"v":-0.6310049999999979,"d":"-0.63100"}]

{"sheet":"Table C2","index":7,"n_rows":138,"n_cols":21,"rows_kept":138,"hidden":true,"merged":[[0,1,0,12]]}
[null,"Table C.2 — Drain diameter as a function of tref /(C1C2) of tref /(C1C3)"]
[]
["tref /(C1C2) or tref /(C1C3)",9.47,6.06,4.21,3.09,2.37,1.87,1.52,1.25,1.05,0.9,0.77,0.67,0.59,0.47,0.38,0.31,0.26,0.22,0.19,0.17]
["Drain diameter (mm)",20,25,30,35,40,45,50,55,60,65,70,75,80,90,100,110,120,130,140,150]
[]
[]
[{"$nulls":4},"tref /(C1C2) or tref /(C1C3)","Drain diameter (mm)",null,"tref /(C1C2) or tref /(C1C3)","Berechneter Wert aus tref und C1 & C2(C3)"]
[{"$nulls":4},{"v":0.17,"d":"0.170"},150,{"$f":"(E18-E8)/10","v":0.001999999999999999},{"$f":"'cockpit calculation ISO 11812'!G40","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"v":0.17200000000000001,"d":"0.172"},149]
[{"$nulls":4},{"v":0.17400000000000002,"d":"0.174"},148]
[{"$nulls":4},{"v":0.17600000000000002,"d":"0.176"},147]
[{"$nulls":4},{"v":0.17800000000000002,"d":"0.178"},146]
[{"$nulls":4},{"v":0.18,"d":"0.180"},145]
[{"$nulls":4},{"v":0.18200000000000002,"d":"0.182"},144]
[{"$nulls":4},{"v":0.18400000000000002,"d":"0.184"},143]
[{"$nulls":4},{"v":0.18600000000000003,"d":"0.186"},142]
[{"$nulls":4},{"v":0.18800000000000003,"d":"0.188"},141]
[{"$nulls":4},{"v":0.19,"d":"0.190"},140,{"$f":"(E28-E18)/10","v":0.003},{"$f":"LOOKUP(H8,E8:E138,F8:F138)","v":{"$error":"#N/A"}},"auf 1mm genauer Tabellenwert drain diameter aus table c.2"]
[{"$nulls":4},0.193,139]
[{"$nulls":4},0.196,138]
[{"$nulls":4},0.199,137]
[{"$nulls":4},0.202,136]
[{"$nulls":4},0.205,135]
[{"$nulls":4},{"v":0.20800000000000002,"d":"0.208"},134]
[{"$nulls":4},{"v":0.21100000000000002,"d":"0.211"},133]
[{"$nulls":4},{"v":0.21400000000000002,"d":"0.214"},132]
[{"$nulls":4},{"v":0.21700000000000003,"d":"0.217"},131]
[{"$nulls":4},{"v":0.22,"d":"0.220"},130,{"$f":"(E38-E28)/10","v":4.000000000000001E-3}]
[{"$nulls":4},0.224,129]
[{"$nulls":4},0.228,128]
[{"$nulls":4},0.232,127]
[{"$nulls":4},{"v":0.23600000000000002,"d":"0.236"},126]
[{"$nulls":4},{"v":0.24,"d":"0.240"},125]
[{"$nulls":4},{"v":0.24400000000000002,"d":"0.244"},124]
[{"$nulls":4},{"v":0.24800000000000003,"d":"0.248"},123]
[{"$nulls":4},0.252,122]
[{"$nulls":4},0.256,121]
[{"$nulls":4},{"v":0.26,"d":"0.260"},120,{"$f":"(E48-E38)/10","v":0.004999999999999999}]
[{"$nulls":4},0.265,119]
[{"$nulls":4},{"v":0.27,"d":"0.270"},118]
[{"$nulls":4},0.275,117]
[{"$nulls":4},{"v":0.28,"d":"0.280"},116]
[{"$nulls":4},0.285,115]
[{"$nulls":4},{"v":0.29,"d":"0.290"},114]
[{"$nulls":4},0.295,113]
[{"$nulls":4},{"v":0.3,"d":"0.300"},112]
[{"$nulls":4},0.305,111]
[{"$nulls":4},{"v":0.31,"d":"0.310"},110,{"$f":"(E58-E48)/10","v":7.000000000000001E-3}]
[{"$nulls":4},0.317,109]
[{"$nulls":4},0.324,108]
[{"$nulls":4},0.331,107]
[{"$nulls":4},0.338,106]
[{"$nulls":4},0.345,105]
[{"$nulls":4},{"v":0.35200000000000004,"d":"0.352"},104]
[{"$nulls":4},{"v":0.35900000000000004,"d":"0.359"},103]
[{"$nulls":4},{"v":0.36600000000000005,"d":"0.366"},102]
[{"$nulls":4},{"v":0.37300000000000005,"d":"0.373"},101]
[{"$nulls":4},{"v":0.38,"d":"0.380"},100,{"$f":"(E68-E58)/10","v":0.008999999999999998}]
[{"$nulls":4},0.389,99]
[{"$nulls":4},0.398,98]
[{"$nulls":4},{"v":0.40700000000000003,"d":"0.407"},97]
[{"$nulls":4},{"v":0.41600000000000004,"d":"0.416"},96]
[{"$nulls":4},0.425,95]
[{"$nulls":4},{"v":0.43400000000000005,"d":"0.434"},94]
[{"$nulls":4},{"v":0.44300000000000006,"d":"0.443"},93]
[{"$nulls":4},{"v":0.45200000000000007,"d":"0.452"},92]
[{"$nulls":4},{"v":0.4610000000000001,"d":"0.461"},91]
[{"$nulls":4},{"v":0.47,"d":"0.470"},90,{"$f":"(E78-E68)/10","v":0.012}]
[{"$nulls":4},0.482,89]
[{"$nulls":4},0.494,88]
[{"$nulls":4},0.506,87]
[{"$nulls":4},0.518,86]
[{"$nulls":4},{"v":0.53,"d":"0.530"},85]
[{"$nulls":4},0.542,84]
[{"$nulls":4},0.554,83]
[{"$nulls":4},{"v":0.5660000000000001,"d":"0.566"},82]
[{"$nulls":4},{"v":0.5780000000000001,"d":"0.578"},81]
[{"$nulls":4},{"v":0.59,"d":"0.590"},80,{"$f":"(E83-E78)/5","v":0.016000000000000014}]
[{"$nulls":4},0.606,79]
[{"$nulls":4},0.622,78]
[{"$nulls":4},0.638,77]
[{"$nulls":4},0.654,76]
[{"$nulls":4},{"v":0.67,"d":"0.670"},75,{"$f":"(E88-E83)/5","v":0.019999999999999997}]
[{"$nulls":4},{"v":0.69,"d":"0.690"},74]
[{"$nulls":4},{"v":0.71,"d":"0.710"},73]
[{"$nulls":4},{"v":0.73,"d":"0.730"},72]
[{"$nulls":4},{"v":0.75,"d":"0.750"},71]
[{"$nulls":4},{"v":0.77,"d":"0.770"},70,{"$f":"(E93-E88)/5","v":0.026000000000000002}]
[{"$nulls":4},0.796,69]
[{"$nulls":4},{"v":0.8220000000000001,"d":"0.822"},68]
[{"$nulls":4},{"v":0.8480000000000001,"d":"0.848"},67]
[{"$nulls":4},{"v":0.8740000000000001,"d":"0.874"},66]
[{"$nulls":4},{"v":0.9,"d":"0.900"},65,{"$f":"(E98-E93)/5","v":0.030000000000000006}]
[{"$nulls":4},{"v":0.93,"d":"0.930"},64]
[{"$nulls":4},{"v":0.96,"d":"0.960"},63]
[{"$nulls":4},{"v":0.99,"d":"0.990"},62]
[{"$nulls":4},{"v":1.02,"d":"1.020"},61]
[{"$nulls":4},{"v":1.05,"d":"1.050"},60,{"$f":"(E103-E98)/5","v":0.039999999999999994}]
[{"$nulls":4},{"v":1.09,"d":"1.090"},59]
[{"$nulls":4},{"v":1.13,"d":"1.130"},58]
[{"$nulls":4},{"v":1.17,"d":"1.170"},57]
[{"$nulls":4},{"v":1.21,"d":"1.210"},56]
[{"$nulls":4},{"v":1.25,"d":"1.250"},55,{"$f":"(E108-E103)/5","v":0.054000000000000006}]
[{"$nulls":4},1.304,54]
[{"$nulls":4},1.358,53]
[{"$nulls":4},{"v":1.4120000000000001,"d":"1.412"},52]
[{"$nulls":4},{"v":1.4660000000000002,"d":"1.466"},51]
[{"$nulls":4},{"v":1.52,"d":"1.520"},50,{"$f":"(E113-E108)/5","v":0.07000000000000002}]
[{"$nulls":4},{"v":1.59,"d":"1.590"},49]
[{"$nulls":4},{"v":1.66,"d":"1.660"},48]
[{"$nulls":4},{"v":1.73,"d":"1.730"},47]
[{"$nulls":4},{"v":1.8,"d":"1.800"},46]
[{"$nulls":4},{"v":1.87,"d":"1.870"},45,{"$f":"(E118-E113)/5","v":0.1}]
[{"$nulls":4},{"v":1.97,"d":"1.970"},44]
[{"$nulls":4},{"v":2.07,"d":"2.070"},43]
[{"$nulls":4},{"v":2.17,"d":"2.170"},42]
[{"$nulls":4},{"v":2.27,"d":"2.270"},41]
[{"$nulls":4},{"v":2.37,"d":"2.370"},40,{"$f":"(E123-E118)/5","v":0.14399999999999996}]
[{"$nulls":4},{"v":2.5140000000000002,"d":"2.514"},39]
[{"$nulls":4},{"v":2.6580000000000004,"d":"2.658"},38]
[{"$nulls":4},{"v":2.8020000000000005,"d":"2.802"},37]
[{"$nulls":4},{"v":2.9460000000000006,"d":"2.946"},36]
[{"$nulls":4},{"v":3.09,"d":"3.090"},35,{"$f":"(E128-E123)/5","v":0.22400000000000003}]
[{"$nulls":4},3.314,34]
[{"$nulls":4},{"v":3.5380000000000003,"d":"3.538"},33]
[{"$nulls":4},{"v":3.7620000000000005,"d":"3.762"},32]
[{"$nulls":4},{"v":3.9860000000000007,"d":"3.986"},31]
[{"$nulls":4},{"v":4.21,"d":"4.210"},30,{"$f":"(E133-E128)/5","v":0.36999999999999994}]
[{"$nulls":4},{"v":4.58,"d":"4.580"},29]
[{"$nulls":4},{"v":4.95,"d":"4.950"},28]
[{"$nulls":4},{"v":5.32,"d":"5.320"},27]
[{"$nulls":4},{"v":5.69,"d":"5.690"},26]
[{"$nulls":4},{"v":6.06,"d":"6.060"},25,{"$f":"(E138-E133)/5","v":0.6820000000000002}]
[{"$nulls":4},6.742,24]
[{"$nulls":4},7.424,23]
[{"$nulls":4},8.106,22]
[{"$nulls":4},8.788,21]
[{"$nulls":4},{"v":9.47,"d":"9.470"},20]

{"sheet":"Koef. C2 Table C3","index":8,"n_rows":29,"n_cols":9,"rows_kept":29,"hidden":true,"merged":[[2,1,2,8]]}
[]
[]
[null,"Table C.3 — Values of C2 for hC = 0,4 m and drain outlet above the waterline"]
["Drain length L(m)","Drain lengthL (m)",null,0.2,0.4,0.6,0.8,1,1.2]
[null,"Drain",25,1.1,1.18,1.25,1.32,1.38,1.45]
[null,null,30,1.09,1.15,1.21,1.26,1.31,1.37]
[null,"diameter",35,1.08,1.13,1.18,1.22,1.27,1.31]
[null,null,40,1.07,1.11,1.15,1.19,1.23,1.27]
[null,"d (mm) =",45,1.07,1.1,1.14,1.17,1.21,1.24]
[null,null,50,1.06,1.09,1.12,1.15,1.18,1.21]
[null,null,55,1.06,1.09,1.11,1.14,1.17,1.19]
[null,null,60,1.05,1.08,1.11,1.13,1.15,1.18]
[null,null,65,1.05,1.08,1.1,1.12,1.14,1.16]
[null,null,70,1.05,1.07,1.09,1.11,1.13,1.12]
[null,null,80,1.05,1.06,1.08,1.1,1.12,1.13]
[null,null,90,1.04,1.06,1.08,1.09,1.11,1.12]
[null,null,100,1.04,1.06,1.07,1.08,1.1,1.11]
[null,null,110,1.04,1.05,1.07,1.08,1.09,1.1]
[null,null,120,1.04,1.05,1.06,1.08,1.08,1.09]
[null,null,130,1.04,1.05,1.06,1.07,1.08,1.09]
[null,null,140,1.04,1.05,1.06,1.07,1.07,1.08]
[null,null,150,1.04,1.05,1.05,1.06,1.07,1.08]
[]
[{"$nulls":3},"C2 ",{"$f":"IF(D26=0,\"\",VLOOKUP(D29,C5:I22,D28,TRUE))","v":{"$error":"#N/A"}}]
[{"$nulls":4},"rounded"]
[null,"actual drain length ",null,{"$f":"'cockpit calculation ISO 11812'!D30","v":""},{"$f":"EVEN(ROUNDDOWN(D26,1)*10)/10","v":{"$error":"#VALUE!"}}]
[null,"rounded drain length",null,{"$f":"IF(E26>1.2,1.2,E26)","v":{"$error":"#VALUE!"}},null,"z.Zt 1,2 größter Tabellenwert; zu ändern"]
[null,"suchkriterium",null,{"$f":"D27/0.2+1","v":{"$error":"#VALUE!"}}]
[null,"first value drain diameter",null,{"$f":"'cockpit calculation ISO 11812'!D41","v":false}]

{"sheet":"Koef. C3 Table C4","index":9,"n_rows":29,"n_cols":9,"rows_kept":29,"hidden":true,"merged":[[2,1,2,8],[3,1,3,2]]}
[]
[]
[null,"Table C.4 — Values of C3 for hC = 0,4 m and drain outlet below the waterline"]
["Drain length L(m)","Drain length L (m)",null,0.2,0.4,0.6,0.8,1,1.2]
[null,"Drain",25,1.49,1.55,1.61,1.67,1.72,1.77]
[null,null,30,1.48,1.53,1.57,1.62,1.66,1.71]
[null,"diameter",35,1.47,1.51,1.55,1.59,1.63,1.69]
[null,null,40,1.47,1.5,1.53,1.57,1.6,1.63]
[null,"d (mm) =",45,1.46,1.49,1.52,1.55,1.58,1.6]
[null,null,50,1.46,1.49,1.51,1.53,1.56,1.58]
[null,null,55,1.46,1.48,1.5,1.52,1.54,1.57]
[null,null,60,1.46,1.47,1.49,1.51,1.53,1.55]
[null,null,65,1.45,1.47,1.49,1.51,1.52,1.54]
[null,null,70,1.45,1.47,1.48,1.5,1.52,1.53]
[null,null,80,1.45,1.46,1.48,1.49,1.5,1.52]
[null,null,90,1.45,1.46,1.47,1.48,1.49,1.51]
[null,null,100,1.45,1.46,1.47,1.48,1.49,1.5]
[null,null,110,1.44,1.45,1.46,1.47,1.48,1.49]
[null,null,120,1.44,1.45,1.46,1.47,1.48,1.49]
[null,null,130,1.44,1.45,1.46,1.47,1.48,1.49]
[null,null,140,1.44,1.45,1.46,1.46,1.47,1.48]
[null,null,150,1.44,1.45,1.45,1.46,1.47,1.47]
[]
[{"$nulls":3},"C2 ",{"$f":"VLOOKUP(D29,C5:I22,D28,TRUE)","v":{"$error":"#N/A"}}]
[{"$nulls":4},"rounded"]
[null,"actual drain length ",null,{"$f":"'cockpit calculation ISO 11812'!D30","v":""},{"$f":"EVEN(ROUNDDOWN(D26,1)*10)/10","v":{"$error":"#VALUE!"}}]
[null,"rounded drain length",null,{"$f":"IF(E26>1.2,1.2,E26)","v":{"$error":"#VALUE!"}},null,"z.Zt 1,2 größter Tabellenwert; zu ändern"]
[null,"suchkriterium",null,{"$f":"D27/0.2+1","v":{"$error":"#VALUE!"}}]
[null,"first value drain diameter",null,{"$f":"'cockpit calculation ISO 11812'!D41","v":false}]